USE BMIG_Mensual_POST_CADENA
go
IF OBJECT_ID('dbo.WASP_M0016_seguros') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.WASP_M0016_seguros
    IF OBJECT_ID('dbo.WASP_M0016_seguros') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.WASP_M0016_seguros >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.WASP_M0016_seguros >>>'
END
go
SET ANSI_NULLS ON
go
SET QUOTED_IDENTIFIER ON
go
CREATE PROCEDURE WASP_M0016_seguros 

AS
BEGIN
select cs.ppsuc, cs.ppcta, cs.ppoper,
       vs.ppimp11 as cod_seg1 , cs.ppimp11 as val_seg1,
       vs.ppimp12 as cod_seg2, cs.ppimp12 as val_seg2,
       vs.ppimp13 as cod_seg3, cs.ppimp13 as val_seg3,
       vs.ppimp14 as cod_seg4, cs.ppimp14 as val_seg4,
       vs.ppimp15 as cod_seg5, cs.ppimp15 as val_seg5,
       vs.ppimp16 as cod_seg6, cs.ppimp16 as val_seg6,
       vs.ppimp17 as cod_seg7, cs.ppimp17 as val_seg7, 
       vs.ppimp18 as cod_seg8, cs.ppimp18 as val_seg8,
       vs.ppimp19 as cod_seg9, cs.ppimp19 as val_seg9
into dbo.sv_seguros
from sv_valores_seguros as cs,
     sv_codigos_seguros as vs
where cs.ppsuc  = vs.ppsuc and
      cs.ppcta  = vs.ppcta and 
      cs.ppoper = vs.ppoper
order by  vs.ppimp11


END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.WASP_M0016_seguros') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.WASP_M0016_seguros >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.WASP_M0016_seguros >>>'
go
